SQLBase 8.5.00 – Fixes List
|
Defect Id |
Description |
|
51702 |
Any table name that begins with "SYS" is viewed as a system
table. SQLConsole should use the
SYSTEM column in SYSTABLES to identify "real" system tables from
user tables. (SQLCONSOLE) |
|
52503 |
Unload of SQLBase does not take into account of RI in respect of
Foreign Keys. (SQLBASE) |
|
65503 |
Calling an External Function that is created to execute in a separate
process, causes the error: "Handle to SQLBase Server is NULL" to
appear in EFHost. (SQLBASE) |
|
68564 |
Calling C/API from External Function DLL does not work properly.
(SQLBASE) |
|
68977 |
SQLBase should allow larger settings for cache - higher than 32,000;
Examples: cache=32000, 64000, 128000, 256000, 384000, 512000,.. (SQLBASE) |
|
71859 |
Getting a GPF or Dr. Watson when issuing a SELECT after you did SET
SCREEN OFF (SQLTALK) |
|
74074 |
SQLBase stops responding to clients after 1801 error. The server GUI
itself is responding, any new connection is visible in the Process activity
window. However, client applications do not receive any response from server.
(SQLBASE) |
|
74113 |
A selection when done with a view which references another view
produces different results than the same select is done without using a
view. The numbers of rows are
identical, but the data is different. (SQLBASE) |
|
74681 |
SQLBASE OLEDB 1.0 Build 12731, when fetching DATATYPE long varchar
using VB or VBSCRIPT, ???? is returned (SQLBASE) |
|
74879 |
Getting Error 10828 SVC DFE (delete file error) when a subdirectory
exists when trying to drop a database.
Database goes away but the entry is left in the sql.ini file.
(SQLBASE) |
|
74880 |
If you try to save a script file as anything other than .sql, a .sql
is appended at the end of the file name. (SQLTALK) |
|
74897 |
Feature request: increase the maximum size of CACHE to 128000 or
higher. Current max is 32000. (SQLBASE) |
|
74899 |
If an invalid keyword is specified in the server sql.ini file, an
error is given but the SQLBase process still remains alive, preventing
SQLBase from starting after the sql.ini error is corrected. The SQLBase process must be killed with
the task manager (SQLBASE) |
|
75129 |
Customer would like to see the win32client name automatically set to
the machine name instead of the default "win32client". But still configurable. (SQLBASE) |
|
75180 |
Like processing gives wrong results using NLS. Using =, !=, > or < in a where
condition of an select, update or delete causes a incorrect result by using
country.sql. (SQLBASE) |
|
75205 |
ERROR : 00166 SQL CRS Cannot create a front-end result set, when
multiple instance of an application using FERS is running. (SQLBASE) |
|
75345 |
The new keyword 'batchpriority' which was introduced in SQLBase 7.6.0
is not yet shown as a default in the 7.6.1 release. (SQLBASE) |
|
76202 |
SQLBase improperly handles surpassing USERS setting. Wrong behavior +
wrong error message. (SQLBASE) |
|
76297 |
Got unhandled exception when stopping SQLBase as a program from SMC on
a system with Visual Studio installed.
Did not happen on another machine that did not have Visual Studio
installed. (SQLBASE) |
|
76420 |
A select statement returns too many rows when using an Exist clause in
the sub-select. If part of the table
is deleted (rows that don't relate to the select), or optimizerlevel=1 is
set, the correct number of rows are returned. (SQLBASE) |
|
76565 |
Stop SQLBase service causes GPF. (SQLBASE) |
|
76597 |
When trying to put labels or comments on a table named TRANSACTION,
the labels and comments go on fine but do not survive an unload/load.
(SQLBASE) |
|
76977 |
Visual Studio.NET: - Unable to Drag and Drop of Table / View / Stored
Procedure object to Data Set / XML Schema Forms. (SQLBASE) |
|
76982 |
using 2 or more letters in the
like clause makes SQLTalk hang. CPU
usage goes to 100%. Happens when used
in combination with outer/inner joins. (SQLBASE) |
|
76999 |
SQLBase OLEDB Provider does not supports LEFT/RIGHT OUTER JOINS which
are generated using Visual Studio database project. (SQLBASE) |
|
77025 |
Simple select from a complex view causes SQLBase to crash. Also
appears in 8.0. (SQLBASE) |
|
77061 |
3rd Party Integration with Crystal Report Writer 9.0: Report generated
using SQLBase ODBC driver with left/right outer joins says "Recordset
Cannot be opened" and then "SQL command ended improperly"
(SQLBASE) |
|
77072 |
Fatal Connect Error when setting recovery ON if the SYSADM password
was altered (SQLTALK) |
|
77077 |
Partition DB doesn't work in Win98 Only. Fails with error:--Error:
00231 DBO IVR Invalid version. (SQLBASE) |
|
77081 |
CRW 8.0 integration with SQLBase OLEDB Provider: Generating report
using SQLBase OLEDB Provider using Left/Right Outer Joins provides an invalid
sql statement. (SQLBASE) |
|
77308 |
When we store a procedure SQLTalk generate message: “Error: 05007 TLK
CTB Command too big -- ignored Data and/or command being skipped Error: 05041
TLK NCF No command found to process”. Stored procedure file length is 23k.
(SQLTALK) |
|
77321 |
Two related problems. SQLBase corrupts SYSCOLAUTH and reportedly other
system tables. The second problem, the one this defect is concerned with, is
that users cannot unload or migrate these databases. (SQLBASE) |
|
77397 |
Incorrect results are returned with a large select. (SQLBASE) |
|
77476 |
SQLBase ODBC driver: Cannot get the data for DATETIME columns having
time stamps for the following scenario from MS Query 2000. (SQLBASE) |
|
77515 |
Database project created using VC++ gives the following error
:[GUPTA][ODBC] 1402 Ambiguous column Name Reference.[GUPTA][ODBC] Function
Sequence Error. (SQLBASE) |
|
77547 |
In SMC, users should be able to refresh the information for all the
nodes and sub nodes under it by doing a refresh from the context menu of node
'SQLBase Server Installations'(Console Root\SQLBase Services\SQLBase Server
Installations) (SQLBASE) |
|
77581 |
When the node Database Node is selected, the values shown for cursors
and Users are 0 though there are open cursors and connections. (SQLBASE) |
|
77591 |
A particular query with OR clause in the main as well as subquery
takes very long time to execute, creates huge tmp file and never seems to complete. The temp file at
the time of failure is 1.5 GB for query against database of 50MB. (SQLBASE) |
|
77614 |
SalTblPopulate fails with SQLBase ole db connectivity and result set
turned on. (SQLBASE) |
|
77656 |
Using SQLBaseOLEDB: Rollback thru SqlPrepareAndExecute &
SQLRollBackSession didn't work even when we set DBP_AUTOCOMMIT as FALSE
using SqlSetParameter. (SQLBASE) |
|
77667 |
1. It is not possible to configure SQLBaseDataAdapter with
Datasets. In the properties window of
SQLBaseDataAdapter attributes SelectCommand, DeleteCommand, InsertCommand and UpdateCommand are
shown grayed. 2. 'Data' tab doesn't
have all objects (SQLBASE) |
|
77714 |
SQLBase JDBC driver Autocommit NON functional. (SQLBASE) |
|
77767 |
SQLBase crashes without FAIL.SQL when an long stored procedure name is
supplied in the EXECUTE command. (SQLBASE) |
|
77801 |
Values of INTEGER columns > 999999 (>= 1000000) with two
trailing zeroes are truncated by the ResultSet.getInt() & getString()
methods using SQLBase JDBC driver. (SQLBASE) |
|
77802 |
Gupta NDP can not convert UNICODE string to non-UNICODE string
correctly. (SQLBASE) |
|
77817 |
When decimal separation uses a coma, selecting numeric columns with
decimals results in an exception in NDP :
System.Format.Exception in Gupta.sqlbase.data.dll (SQLBASE) |
|
77824 |
Default isolation for ODBC DSN is RR, and should be RL. (SQLBASE) |
|
77839 |
No cursor context preservation possible with the SQLBase JDBC driver
giving error: java.sql.SQLException: 00201 DBO NCC No compiled command.
(SQLBASE) |
|
77860 |
The installer for the SQLBase Driver pack does not update the path.
(SQLBASE DRIVER PACK) |
|
77862 |
User needs to cast his objects to SQLBase* if he returns it from some method/ property of existing interfaces. (SQLBASE) |
|
77887 |
SQLBase JDBC driver does not support configuring of IMS
(InputMessageSize) and OMS (OutputMessageSize) (SQLBASE DRIVER PACK) |
|
77889 |
Specifying longer database name in the JDBC URL causes SQLBase to
crash/disappear (SQLBASE DRIVER PACK) |
|
77894 |
JDBC connection string has been changed to optionally include the
input and output message size to improve the performance. (SQLBASE DRIVER
PACK) |
|
77897 |
A customer is reporting a silent death of a SQLBase. The server aborts
without any message and without writing anything to fail.sql. (SQLBASE) |
|
77903 |
SQLBase ODBC driver when configured as subscriber to SQL Server 2000
in Enterprise Manager says "Invalid Cursor State Error:
2400".Because of which the agent gets crashed. (SQLBASE) |
|
77905 |
When a user creates a hashtable of Connection objects, occasionally,
the JVM will throw an SQLException 01303 MFE NCO Not connected. When this
happens, the SQLBase Server Status window will show IDLE0000000000 among the
'normal' JDBCClient Client Node. (SQLBASE DRIVER PACK) |
|
77906 |
SQLBase OLEDB Provider connection string needs to optionally include
IMS(Input Message Size) and OMS(Output message size) to improve the
performance similar to JDBC driver connection string. (SQLBASE DRIVER PACK) |
|
77925 |
The maximum connections could be made with SQLBase is 125. When trying
to perform 126th connection, the time out exception will be thrown after
waiting for 15 minutes. This should be changed to 1 minute. (SQLBASE DRIVER
PACK) |
|
77938 |
Doing a select * from an empty table with long varchar columns doesn't
list long varchar columns in the output window. (SQLTALK) |
|
77946 |
Customer is not able to use Transaction Isolation levels (
TRANSACTION_SERIALIZABLE, TRANSACTION_READ_COMMITTED ) after the fixing of
the Auto Commit issue. (SQLBASE DRIVER PACK) |
|
77952 |
Prior releases of SQLBase allowed a 1-user server to be installed when
SQLConsole was selected and there was no existing SQLBase server installed. (SQLBASE) |
|
77953 |
The default isolation level returned from JDBC driver differs from the
one actually set in the SQLBase server. (SQLBASE DRIVER PACK) |
|
77954 |
The SQLBase JDBC driver isolation levels mapping to SQLBase isolations
are not correct. (SQLBASE DRIVER PACK) |
|
77955 |
You can't set the centurydefaultmode keyword using the Connectivity
Administrator. The error message that
is thrown is "You cannot set reserved keywords." You can, however, set this manually to 1
by editing the sql.ini file directly. (SQLBASE) |
|
77965 |
Transaction Isolation levels for the SQLBase JDBC driver has been
changed to map it correctly with SQLBase. (SQLBASE DRIVER PACK) |
|
77978 |
Unable to view the tables in PowerBuilder, when connected to SQLBase
server through ODBC driver. (SQLBASE DRIVER PACK) |
|
78031 |
SQLBase server shuts down abnormally when the identifier used in SQL
command is very big(close to 10000 characters). Nothing is getting written to
Fail.sql (SQLBASE) |
|
78059 |
JDBC connection instability with exceptions in jdbc.gupta.sqlbase.SqlbaseException:
createCursor(): unknown session! AND 00135 SQL ICN Invalid cursor number
(SQLBASE DRIVER PACK) |
|
78060 |
IRowsetChange does not update a row when done through RowsetViewer.exe
(SQLBASE DRIVER PACK) |
|
78101 |
The ColumInfo of a column created as a float and number DATA_TYPE
returns DBTYPE_R4 and DBTYPE_R8 respectively while their DATA_TYPE returned
by SCHEMA_PROVIDERS_TYPE are DBTYPE_R8, DBTYPE_NUMERIC respectively, which
deviates from OLEDB specification. (SQLBASE DRIVER PACK) |
|
78113 |
SQLBase crashes when Update Statistics is executed while isolation
level is set to Read Only (SQLBASE) |
|
78127 |
SQLBase OLEDB Provider is giving error message when trying to insert
into a table with quoted columns. (SQLBASE DRIVER PACK) |
|
78142 |
Error "999 SQLSTATE = IM001 [Gupta][ODBC Driver]Driver does not
support this function" when accessing SQLBase via ODBC from PowerBuilder
application. Cannot be reproduced from old Merant ODBC driver. (SQLBASE
DRIVER PACK) |
|
78215 |
Listenport entry not possible thru Connectivity Administrator
(SQLBASE) |
|
78293 |
Unloading and Loading of a database which has triggers in double
quotes gives error 'Delimited identifier is too long' error. (SQLBASE) |
|
78315 |
Unhandled Exception: Gupta.SQLBase.Data.SQLBaseException: Failed to
create a database cursor for the command. (SQLBASE) |
|
78317 |
If the database we are dropping is the only one database in the server
then dropping that DB will still show the name in Database window of server
GUI. (SQLBASE) |
|
78460 |
Server gives 'Active users connected' message box when we try to stop
Server running as a program from SMC although no user sessions are started.
(SQLBASE) |
|
78491 |
Infinite loop of "5169 TLK ICH Invalid character" errors
when trying to store a procedure. Only way to stop is
<Ctrl>+<Alt>+<Del>. (SQLBASE) |
|
78590 |
OLEDB Provider returns 0 (ZERO) for null values in the numeric data
type columns. (SQLBASE DRIVER PACK) |
|
78599 |
when retry and retrytimeout are set SQLTalk gives error. (SQLBASE) |
|
78625 |
Got error 135 when trying to do SQLSCL(set client name) on a SQLTCUR
that was returned by a call to SQLOPC. The cursor handle was valid (could be
used for other API calls), but, the call to SQLSCL failed. (SQLBASE) |
|
78650 |
With CR8,we are not able to create any report using tables. (SQLBASE
DRIVER PACK) |
|
78696 |
SQLTalk picking the wrong talk.hlp, actually the one found in the
path. (SQLTALK) |